package com.mrtan.service;

import com.mrtan.bean.Customer;
import com.mrtan.vo.CustomerVO;
import com.mrtan.vo.CustomerWhereVO;

import java.util.List;
import java.util.Map;

public interface CustomerService {

    List<String> selectNames();

    //查询所有客户(含模糊查询)
    List<Customer> selectAll(CustomerWhereVO customerWhereVO);

    //增加用户
    int insertSelective(CustomerVO CustomerVO);

    //删除用户
    int deleteByPrimaryKey(Integer id);

    //修改用户信息
    int updateByPrimaryKeySelective(CustomerVO CustomerVO);

    //查询用户订单数
    int  selectOrderCount(String customerName);

    List<Map<Customer,Integer>> getCustomerOrderSum(Integer month);

    List<Map<String, Object>> selectTotalAmountByCustomerAndTime(Integer month);

    List<Map<String, Object>> selectTotalorderByCustomerTime();
}
